package so.ifl.servcie;

import java.util.List;
import java.util.Map;

import org.springframework.transaction.annotation.Transactional;

import so.ifl.vo.ConsultVo;
/**
 * @author simon
 * create at 2011-12-26 下午5:48:32
 * <mailto:liangyuanliu@gmail.com>
 */
@Transactional
public interface ConsultService {
	/**
	 * /查询离相应“期望报培时间”短于3天的学员用于回访
	 * create by simon
	 * create at 2011-12-26 下午5:49:53
	 * <mailto:liangyuanliu@gmail.com>
	 * @param param
	 * @return
	 */
	
	public List<ConsultVo> queryConsultWithTimeToRemind(Map<String, Object> param, Integer offset, Integer limit);
	
	/**
	 * 统计回仿信息
	 * simon
	 * create at 2012-1-16 上午11:50:49
	 * <mailto:liangyuanliu@gmail.com>
	 * @param param
	 * @return
	 */
	public int countConsultWithTimeToRemind(Map<String, Object> param);
	
	/**
	 * 分页查询咨询信息
	 * create by simon
	 * create at 2011-12-26 下午5:50:16
	 * <mailto:liangyuanliu@gmail.com>
	 * @param param
	 * @param rowBounds
	 * @return
	 */
	public List<ConsultVo> queryConsultWithParamAndPagination(Map<String, Object> params, Integer offset, Integer limit);
	/**
	 * 统计咨询信息
	 * create by simon
	 * create at 2011-12-26 下午5:50:56
	 * <mailto:liangyuanliu@gmail.com>
	 * @param param
	 * @return
	 */
	public int countConsultWithParam(Map<String, Object> param);

	/**
	 * 新增咨询信息
	 * create by simon
	 * create at 2011-12-26 下午5:51:14
	 * <mailto:liangyuanliu@gmail.com>
	 * @param param
	 */
	public void insertConsult(Map<String, Object> param);
	/**
	 * 更新咨询信息
	 * create by simon
	 * create at 2011-12-26 下午5:51:18
	 * <mailto:liangyuanliu@gmail.com>
	 * @param param
	 */
	public void updateConsult(Map<String, Object> param);
	/**
	 * 删除咨询信息
	 * create by simon
	 * create at 2011-12-26 下午5:51:21
	 * <mailto:liangyuanliu@gmail.com>
	 * @param companyId
	 */
	public void deleteConsult(Integer companyId);

}
